package com.logica.mdm.webservices.messages;

/**
 * Constants utility class for MDM Search by Phone Number.
 */
public class SearchPartyByPhoneNumberConstants {

	/*public static final String PARTY_ID_SEARCH_QUERY = "SELECT DISTINCT mv_pkg_ws_party_phone.party_id"
			+ " FROM mv_pkg_ws_party_phone"
			+ " WHERE (TRIM(mv_pkg_ws_party_phone.dom) = :homePhone"
			+ " OR TRIM(mv_pkg_ws_party_phone.por) = :cellPhone"
			+ " OR TRIM(mv_pkg_ws_party_phone.bur) = :workPhone"
			+ " OR TRIM(mv_pkg_ws_party_phone.fax) = :faxPhone)";*/
	
	public static final String PARTY_ID_SEARCH_QUERY = "SELECT DISTINCT mv_pkg_ws_party_phone.party_id"
			+ " FROM mv_pkg_ws_party_phone"
			+ " WHERE (mv_pkg_ws_party_phone.dom = RPAD(:homePhone,13, ' ')"
			+ " OR mv_pkg_ws_party_phone.por = RPAD(:cellPhone,13, ' ')"
			+ " OR mv_pkg_ws_party_phone.bur = RPAD(:workPhone,13, ' ')"
			+ " OR mv_pkg_ws_party_phone.fax = RPAD(:faxPhone,13, ' '))";

}
